package com.kws.merchant.mapper;

import com.kws.merchant.domain.OperationTicketMember;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * 两票-工作票-成员(OperationTicketMember)表数据库访问层
 *
 * @author yxy
 * @since 2024-12-20 16:30:06
 */

public interface OperationTicketMemberMapper extends BaseMapper<OperationTicketMember> {


    @Select("Select o.*,u.nick_name as userName from tb_operation_ticket_member o left join sys_user u on o.user_id=u.user_id where o.ticket_id=${id}")
    List<OperationTicketMember> listByTicketId(@Param("id") Long id);
}
